<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/QQ648472886/article/details/78936040"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql 内存不足引发的坑 - QQ648472886的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql 内存不足引发的坑 - QQ648472886的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "QQ648472886";
        var blog_address = "https://blog.csdn.net/qq648472886";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/QQ648472886/article/details/78936040"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql 内存不足引发的坑";
        var articleDesc = "问题：[root@iZuzc9f4ma6h2iZ~]#servicemysqldrestartMySQLserverPIDfilecouldnotbefound![FAILED]StartingMySQL.Loggingto/var/log/mysql/error.log.Theserverquitwithout";
        // 第四范式所需数据
        var articleTitles = "mysql 内存不足引发的坑 - QQ648472886的博客";
        
        var nickName = "redmojo";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/qq648472886/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/QQ648472886/article/details/78936040";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql 内存不足引发的坑</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年12月30日 09:13:28</span>
                    <a class="follow-nickName" href="https://me.csdn.net/QQ648472886" target="_blank">redmojo</a>
                    <span class="read-count">阅读数 2695</span>
                                                                        <span class="tags-box artic-tag-box">
                <span class="label">标签：</span>
                                                                <a data-report-click='{"mod":"popu_626","strategy":"mysql"}' data-report-view='{"mod":"popu_626","strategy":"mysql"}' class="tag-link" href="https://so.csdn.net/so/search/s.do?q=mysql&t=blog" target="_blank">mysql                                                    </a>
              </span>
                                                                                                            </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            
<h2>问题：</h2>
<p></p>
<pre><code class="language-plain"><span style="font-size:14px;">[root@iZuzc9f4ma6h2iZ ~]# service mysqld restart<strong>
</strong>MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.Logging to '/var/log/mysql/error.log'.
The server quit without updating PID file (/data/mysql/iZuz[FAILED]2iZ.pid).</span></code></pre><br />
第一直觉告诉我google “ MySQL server PID file could not be found!  [FAILED]”，可基本没什么用。
<p></p>
<p>后开有人说看看报错信息，于是：</p>
<p></p>
<pre><code class="language-plain"><span style="font-size:14px;">[root@iZuzc9f4ma6h2iZ ~]# tail -n 50 /data/mysql/iZuzc9f4ma6h2iZ.err
InnoDB: mmap(137363456 bytes) failed; errno 12
2017-12-28 17:09:44 25065 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2017-12-28 17:09:44 25065 [ERROR] Plugin 'InnoDB' init function returned error.
2017-12-28 17:09:44 25065 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-12-28 17:09:44 25065 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-12-28 17:09:44 25065 [ERROR] Aborting</span></code></pre><br /><p></p>
<p><a href="https://stackoverflow.com/questions/25965638/mysql-fatal-error-cannot-allocate-memory-for-the-buffer-pool/32932601" rel="nofollow" data-token="03cfbd445cd617974ea4a4679c3483a5">这里需要解释一下，我直接贴上来了</a></p>
<p></p>
<ul style="border:0px;font-size:15px;line-height:inherit;font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;vertical-align:baseline;color:rgb(36,39,41);"><li style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;">
Out of memory error: <code style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:13px;line-height:inherit;font-family:Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif;vertical-align:baseline;">InnoDB:
 Fatal error: cannot allocate memory for the buffer pool</code></li><li style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;">
InnoDB can't start without enough memory <code style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:13px;line-height:inherit;font-family:Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif;vertical-align:baseline;">[ERROR]
 Plugin 'InnoDB' init function returned error.[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[ERROR] Unknown/unsupported storage engine: InnoDB[ERROR] Aborting</code></li><li style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;">
mysqld is shutting down, which in this context, really means failing to restart! <code style="border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:13px;line-height:inherit;font-family:Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif;vertical-align:baseline;">[Note]
 /usr/sbin/mysqld: Shutdown complete</code></li></ul>
ok，明白了吗？
<p></p>
<p>于是继续，来看看内存占用情况：</p>
<p></p>
<pre><code class="language-plain"><span style="font-size:18px;">[root@iZuzc9f4ma6h2iZ ~]# free -m
              total        used        free      shared  buff/cache   available
Mem:            992         435         413           1         142         403
Swap:             0           0           0</span></code></pre>
<p></p>
<p>显然，结果很磕馋。内存仅413M，而且没有 Swap 分区。</p>
<p>那么问题来了，mysql 启动到底需要多少内存？</p>
<p>官网是这什么回答的：</p>
<p><br /></p>
<p><a href="https://dev.mysql.com/doc/refman/5.7/en/memory-use.html" rel="nofollow" data-token="9b012e1f2e9bbefb1144b235a78a0d82">How MySQL Uses Memory</a>？</p>
<p><br />
MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately<strong>512MB of RAM.</strong> You can improve MySQL performance
 by increasing the values of certain cache and buffer-related system variables. You can also modify the default configuration to run MySQL on systems with limited memory.<br /></p>
<p></p>
<p></p>
<p><a href="https://www.cnblogs.com/musings/p/5913225.html" rel="nofollow" data-token="800ef183ff04e05e637c9edeadee890b">于是，那么有什么办法可以小内存启动 mysql 吗？</a></p>
<p>答案是有，</p>
<p><strong>vim /etc/my.cnf</strong><br /></p>
<p>添加：</p>
<p></p>
<pre style="font-family:'Courier New' !important;"><span style="line-height:1.5 !important;">performance_schema_max_table_instances</span>=<span style="color:rgb(128,0,128);line-height:1.5 !important;">200</span><span style="line-height:1.5 !important;">
table_definition_cache</span>=<span style="color:rgb(128,0,128);line-height:1.5 !important;">200</span><span style="line-height:1.5 !important;">
table_open_cache</span>=<span style="color:rgb(128,0,128);line-height:1.5 !important;">128</span></pre>
<br /><p></p>
<p>ok，再次运行<strong> service mysqld restart </strong>，没什么问题。</p>
                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/QQ648472886/article/details/78936040","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/QQ648472886/article/details/78936040","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="78936040">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/miyatang/article/details/54881547","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/miyatang/article/details/54881547" target="_blank" title="MySQL性能的五大配置参数(内存参数)">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>性能的五大配置参数(内存参数)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/miyatang/article/details/54881547" target="_blank" title="MySQL性能的五大配置参数(内存参数)">
				<span class="desc oneline">内存参数：存储引擎/共享日志缓冲区，缓冲区池oinnodb_buffer_pool_sizeoinnodb_additional_mem_pool_sizeoinnodb_log_buffer_siz...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/miyatang">来自：	<span class="blog_title"> 好记忆也需烂博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/learner198461/article/details/53455014","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/learner198461/article/details/53455014" target="_blank" title="阿里云mysql内存不足解决办法">
		<h4 class="text-truncate oneline">
				阿里云<em>mysql</em><em>内存不足</em>解决办法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-04</span>
				<span class="read-num hover-hide">
					阅读数 
					3591</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/learner198461/article/details/53455014" target="_blank" title="阿里云mysql内存不足解决办法">
				<span class="desc oneline">场景：有一台阿里云1核1GB内存，安装是windows系统，安装mysql5.6后，启动内存为400多M。这种默认设置会导致内存不足解决：先查找到My.ini文件的位置，点击系统服务，查看命令行修改如...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/learner198461">来自：	<span class="blog_title"> bee-factory</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34354173/article/details/89649995","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34354173/article/details/89649995" target="_blank" title="Centos运行Mysql因为内存不足进程被杀">
		<h4 class="text-truncate oneline">
				Centos运行<em>Mysql</em>因为<em>内存不足</em>进程被杀		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-16</span>
				<span class="read-num hover-hide">
					阅读数 
					26</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34354173/article/details/89649995" target="_blank" title="Centos运行Mysql因为内存不足进程被杀">
				<span class="desc oneline">今天刚刚申请了一个新的域名，在申请完域名刚准备绑定给小伙伴分享注册新域名的喜悦时，刚把网站发到我们小伙伴们的讨论群里，却发现访问不了了，提示，数据库连接失败！真的时一个尴尬.....所有人都进不了我的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34354173">来自：	<span class="blog_title"> weixin_34354173的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012572955/article/details/54600153","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012572955/article/details/54600153" target="_blank" title="mysql5.6.20配置，解决占用内存太大问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>5.6.20配置，解决占用内存太大问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-18</span>
				<span class="read-num hover-hide">
					阅读数 
					5985</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012572955/article/details/54600153" target="_blank" title="mysql5.6.20配置，解决占用内存太大问题">
				<span class="desc oneline">vps的内存为512M,安装好nginx,php等启动起来,mysql死活启动不起来看了日志只看到对应pid被结束了,后跟踪看发现是内存不足被killed;调整my.cnf参数,重新配置（系统默认配置...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012572955">来自：	<span class="blog_title"> u012572955的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/dc666/article/details/78901341","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/dc666/article/details/78901341" target="_blank" title="记一次Mysql占用内存过高的优化过程">
		<h4 class="text-truncate oneline">
				记一次<em>Mysql</em>占用内存过高的优化过程		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-26</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/dc666/article/details/78901341" target="_blank" title="记一次Mysql占用内存过高的优化过程">
				<span class="desc oneline">一.环境说明操作系统：CentOS6.5x86_64数据库：Mysql5.6.22服务器：阿里云VPS，32GMem，0swap二.问题情况：1.某日发现公司线上系统的Mysql某个实例的从库长时间内...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/dc666">来自：	<span class="blog_title"> 克隆大菠萝的后庭</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390307631","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<a href="https://bbs.csdn.net/topics/390307631" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>访问量稍大，就会内存占满而停止，请帮忙分析一下原因		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-06</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">是一个商城系统，ZENCART的 点击量每天也有几十万次吧 现在是我的独立服务器基本上无法连续运行24小时过， 一般连续运行不到20小时，就会出现数据库停止不运行的情况。 这时当然就无法连接数据库了。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hot88zh/article/details/83947962","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hot88zh/article/details/83947962" target="_blank" title="64MB VPS 上优化 MySQL">
		<h4 class="text-truncate oneline">
				64MB VPS 上优化 <em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-18</span>
				<span class="read-num hover-hide">
					阅读数 
					18</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hot88zh/article/details/83947962" target="_blank" title="64MB VPS 上优化 MySQL">
				<span class="desc oneline">MySQL是一个很棒的opensource数据库引擎，大部分的网站和博客都是由MySQL驱动的。MySQL的默认安装占用的内存资源比较大（相对于一个只有64MB的VPS来说），优化MySQL可以减少内...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hot88zh">来自：	<span class="blog_title"> WalleZhang的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Solmyr_biti/article/details/53858345","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Solmyr_biti/article/details/53858345" target="_blank" title="MYSQL经常挂，怀疑内存不够，加SWAP优化">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>经常挂，怀疑内存不够，加SWAP优化		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-24</span>
				<span class="read-num hover-hide">
					阅读数 
					4403</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Solmyr_biti/article/details/53858345" target="_blank" title="MYSQL经常挂，怀疑内存不够，加SWAP优化">
				<span class="desc oneline">如题，最近http://www.12reads.cn/的MYSQL经常挂，最近挂的LOG：Attime:WedDec709:15:01CST2016:MySQLerrorstop.Attime:Wed...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Solmyr_biti">来自：	<span class="blog_title"> Anthony的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xianglingchuan/article/details/77074827","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xianglingchuan/article/details/77074827" target="_blank" title="服务器内存不足Mysql启动错误记录">
		<h4 class="text-truncate oneline">
				服务器<em>内存不足</em><em>Mysql</em>启动错误记录		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-10</span>
				<span class="read-num hover-hide">
					阅读数 
					647</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xianglingchuan/article/details/77074827" target="_blank" title="服务器内存不足Mysql启动错误记录">
				<span class="desc oneline">服务器内存不足Mysql启动错误记录</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xianglingchuan">来自：	<span class="blog_title"> 简单-生活</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/edwzhang/article/details/5875064","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/edwzhang/article/details/5875064" target="_blank" title="内存不够用，启动不了MySQL">
		<h4 class="text-truncate oneline">
				内存不够用，启动不了<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-10</span>
				<span class="read-num hover-hide">
					阅读数 
					8115</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/edwzhang/article/details/5875064" target="_blank" title="内存不够用，启动不了MySQL">
				<span class="desc oneline">innodb_buffer_pool_size的配置要和机器相匹配</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/edwzhang">来自：	<span class="blog_title"> edwzhang的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bj123nimab/article/details/84693673","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bj123nimab/article/details/84693673" target="_blank" title="解决: g++: internal compiler error: Killed (program cc1plus)">
		<h4 class="text-truncate oneline">
				解决: g++: internal compiler error: Killed (program cc1plus)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-30</span>
				<span class="read-num hover-hide">
					阅读数 
					56</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bj123nimab/article/details/84693673" target="_blank" title="解决: g++: internal compiler error: Killed (program cc1plus)">
				<span class="desc oneline">g++:internalcompilererror:Killed(programcc1plus)Pleasesubmitafullbugreport, 主要原因大体上是因为内存不足,有点坑临时使用交换...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bj123nimab">来自：	<span class="blog_title"> 过客阵营 -- 简单的就要最简单</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/QQ648472886/article/details/78936153","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/QQ648472886/article/details/78936153" target="_blank" title="内存不足，mysql 导致启动失败">
		<h4 class="text-truncate oneline">
				<em>内存不足</em>，<em>mysql</em> 导致启动失败		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-30</span>
				<span class="read-num hover-hide">
					阅读数 
					615</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/QQ648472886/article/details/78936153" target="_blank" title="内存不足，mysql 导致启动失败">
				<span class="desc oneline">问题：mysql启动报错</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/QQ648472886">来自：	<span class="blog_title"> QQ648472886的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34417200/article/details/93818978","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34417200/article/details/93818978" target="_blank" title="解决mySQL占用内存超大问题">
		<h4 class="text-truncate oneline">
				解决<em>mySQL</em>占用内存超大问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-15</span>
				<span class="read-num hover-hide">
					阅读数 
					17</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34417200/article/details/93818978" target="_blank" title="解决mySQL占用内存超大问题">
				<span class="desc oneline">为了装mysql环境测试，装上后发现启动后mysql占用了很大的虚拟内存，达8百多兆。网上搜索了一下，得到高人指点my.ini。再也没见再详细的了..只好打开my.ini逐行的啃，虽然英文差了点，不过...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34417200">来自：	<span class="blog_title"> weixin_34417200的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010433704/article/details/51296630","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010433704/article/details/51296630" target="_blank" title="PHP大量数据循环时内存耗尽问题的解决方案（适用于导出大量数据时内存耗尽情况）">
		<h4 class="text-truncate oneline">
				PHP大量数据循环时内存耗尽问题的解决方案（适用于导出大量数据时内存耗尽情况）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1185</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010433704/article/details/51296630" target="_blank" title="PHP大量数据循环时内存耗尽问题的解决方案（适用于导出大量数据时内存耗尽情况）">
				<span class="desc oneline">最近在开发一个PHP程序时遇到了下面的错误：PHPFatalerror:Allowedmemorysizeof268435456bytesexhausted错误信息显示允许的最大内存已经耗尽。遇到这样...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010433704">来自：	<span class="blog_title"> 风的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fantasydreams/article/details/45459653","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fantasydreams/article/details/45459653" target="_blank" title="Mysql网络断开重连问题">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>网络断开重连问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5132</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fantasydreams/article/details/45459653" target="_blank" title="Mysql网络断开重连问题">
				<span class="desc oneline">最近做一个项目的后台守护程序，需要多线程对mysql数据库服务进行操作，为了加强守护撑的健壮性，特地连接成功后拔掉网线，然后测试守护程序断开重新连接的健壮性，可是发现网络断开后，重新插上网线，用mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fantasydreams">来自：	<span class="blog_title"> fantasydreams的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/mozes1/article/details/41315377","strategy":"searchFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/mozes1/article/details/41315377" target="_blank" title="mysql大量数据操作 内存不足 等等问题汇总">
		<h4 class="text-truncate oneline">
				<em>mysql</em>大量数据操作 <em>内存不足</em> 等等问题汇总		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-20</span>
				<span class="read-num hover-hide">
					阅读数 
					2078</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/mozes1/article/details/41315377" target="_blank" title="mysql大量数据操作 内存不足 等等问题汇总">
				<span class="desc oneline">1.大量数据操作时，会出现</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_30512785/article/details/97880047","strategy":"searchFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30512785/article/details/97880047" target="_blank" title="mysqld: Out of memory 解决办法(mysql)">
		<h4 class="text-truncate oneline">
				<em>mysql</em>d: Out of memory 解决办法(<em>mysql</em>)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-05</span>
				<span class="read-num hover-hide">
					阅读数 
					23</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30512785/article/details/97880047" target="_blank" title="mysqld: Out of memory 解决办法(mysql)">
				<span class="desc oneline">自己配置的XWAMP环境，默认下没有详细配置mysql的my.ini，一方面不同服务器的配置不一样，另一方面按照默认为空的方式也一直没有出现过问题。不过最近服务器挂掉了，出现的症状是：网站不能打开，动...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30512785">来自：	<span class="blog_title"> weixin_30512785的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16681169/article/details/51469185","strategy":"searchFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_16681169/article/details/51469185" target="_blank" title="mysql内存已满错误解决（ErrorCode28)">
		<h4 class="text-truncate oneline">
				<em>mysql</em>内存已满错误解决（ErrorCode28)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					3797</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_16681169/article/details/51469185" target="_blank" title="mysql内存已满错误解决（ErrorCode28)">
				<span class="desc oneline">今天在创建数据库和设计表时出现过比如： Errorwritingfile'./solomo/activity.frm'(Errcode:28)的错误看到Errode:28,我查了一下：[plain] ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_16681169">来自：	<span class="blog_title"> zxcodestudy</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lq491040758/article/details/85990165","strategy":"BlogCommendFromQuerySearch","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lq491040758/article/details/85990165" target="_blank" title="C# 服务端 Sqllite数据库结构  引发类型为“System.OutOfMemoryException 的异常 处理总结">
		<h4 class="text-truncate oneline">
				C# 服务端 Sqllite数据库结构  <em>引发</em>类型为“System.OutOfMemoryException 的异常 处理总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1711</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lq491040758/article/details/85990165" target="_blank" title="C# 服务端 Sqllite数据库结构  引发类型为“System.OutOfMemoryException 的异常 处理总结">
				<span class="desc oneline"> 异常情况： 1.引发类型为“System.OutOfMemoryException”的异常。 2.存储空间不足，无法处理此命令。(异常来自HRESULT:0x80070008) 3. Outofme...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lq491040758">来自：	<span class="blog_title"> ToBA#的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wangyinggai151/article/details/81559686","strategy":"BlogCommendFromQuerySearch","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wangyinggai151/article/details/81559686" target="_blank" title="IIS7网站经常报System.OutOfMemoryException解决方法，如何合理设置内存使用情况（KB）（M)值">
		<h4 class="text-truncate oneline">
				IIS7网站经常报System.OutOfMemoryException解决方法，如何合理设置内存使用情况（KB）（M)值		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-10</span>
				<span class="read-num hover-hide">
					阅读数 
					2234</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wangyinggai151/article/details/81559686" target="_blank" title="IIS7网站经常报System.OutOfMemoryException解决方法，如何合理设置内存使用情况（KB）（M)值">
				<span class="desc oneline">最近IIS7网站经常报System.OutOfMemoryException，重启下IIS就可以了，上网查了下是内存溢出了，解决办法：设置回收机制，打开应用线程池，选中网站线程池，点击正在回收，就可以...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wangyinggai151">来自：	<span class="blog_title"> wangyinggai151的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cug_jiang126com/article/details/51984628","strategy":"BlogCommendFromQuerySearch","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cug_jiang126com/article/details/51984628" target="_blank" title="故障案例--mysql5.5分区表的一个坑">
		<h4 class="text-truncate oneline">
				故障案例--<em>mysql</em>5.5分区表的一个坑		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-21</span>
				<span class="read-num hover-hide">
					阅读数 
					6885</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cug_jiang126com/article/details/51984628" target="_blank" title="故障案例--mysql5.5分区表的一个坑">
				<span class="desc oneline">故障现象db每隔一段时间就异常重启，查看DB错误日志的错误日志Databasewasnotshutdownnormally相关的信息，而查看/var/log/message并没有发现什么异常，没有发生...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cug_jiang126com">来自：	<span class="blog_title"> cug_jiang126com的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_36922927/article/details/89704899","strategy":"BlogCommendFromQuerySearch","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_36922927/article/details/89704899" target="_blank" title="cocos 的一个小坑">
		<h4 class="text-truncate oneline">
				cocos 的一个小坑		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-30</span>
				<span class="read-num hover-hide">
					阅读数 
					58</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_36922927/article/details/89704899" target="_blank" title="cocos 的一个小坑">
				<span class="desc oneline">CCASSERT(_rotationZ_X==_rotationZ_Y,&quot;CCNode#rotation.RotationX!=RotationY.Don'tknowwhichonetoreturn&quot;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_36922927">来自：	<span class="blog_title"> forethought.top的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/myhbwh/9133675","strategy":"BlogCommendFromQuerySearch","index":"22"}'>
		<a href="https://download.csdn.net/download/myhbwh/9133675" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						Net 内存溢出（System.OutOfMemoryException）的常见情况和处理方式总结					</h4>
					<span class="data float-right">09-23</span>
				</div>
				<div class="desc oneline">
						在什么情况下会出现OutOfMemonryException呢? 在我们试图新建一个对象时,而垃圾收集器又找不到任何可用内存时被抛出,这种情况下我们是可以捕获该
异常的; 另一种情况是,CLR需要内存时,而却系统却不能提供,也会抛出该异常...				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012377333/article/details/80359985","strategy":"BlogCommendFromMachineLearnPai2","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012377333/article/details/80359985" target="_blank" title="【MySQL故障】----虚拟内存不足挂掉了">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>故障】----虚拟<em>内存不足</em>挂掉了		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-18</span>
				<span class="read-num hover-hide">
					阅读数 
					319</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012377333/article/details/80359985" target="_blank" title="【MySQL故障】----虚拟内存不足挂掉了">
				<span class="desc oneline">【故障现象】  MySQL服务器莫名奇妙的挂掉，并且开启不了。TheserverquitwithoutupdatingPIDfile(/[FAILED]mysql/iZ2ze2hchind7gwe2i...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012377333">来自：	<span class="blog_title"> This My Life - chisj</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34185320/article/details/93391251","strategy":"BlogCommendFromMachineLearnPai2","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34185320/article/details/93391251" target="_blank" title="MySQL内存调优">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>内存调优		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					6</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34185320/article/details/93391251" target="_blank" title="MySQL内存调优">
				<span class="desc oneline">原文链接:MySQLMemoryAllocation--byRickJames原文日期:Created2010;RefreshedOct,2012,Jan,2014翻译人员:铁锚翻译日期:2014年5...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34185320">来自：	<span class="blog_title"> weixin_34185320的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010716706/article/details/78638340","strategy":"BlogCommendFromMachineLearnPai2","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010716706/article/details/78638340" target="_blank" title="mysql编译安装过程内存不足">
		<h4 class="text-truncate oneline">
				<em>mysql</em>编译安装过程<em>内存不足</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1927</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010716706/article/details/78638340" target="_blank" title="mysql编译安装过程内存不足">
				<span class="desc oneline">mysql编译安装过程，执行make命令时报错：c++:internalcompilererror:Killed(programcc1plus)Pleasesubmitafullbugreport,w...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010716706">来自：	<span class="blog_title"> 剑心在野</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_29216579/article/details/82683561","strategy":"BlogCommendFromMachineLearnPai2","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_29216579/article/details/82683561" target="_blank" title="Mysql经常挂掉，挂掉后启动不起来。可能是linux 内存不足，无法分配内存缓冲池导致">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>经常挂掉，挂掉后启动不起来。可能是linux <em>内存不足</em>，无法分配内存缓冲池导致		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-13</span>
				<span class="read-num hover-hide">
					阅读数 
					3819</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_29216579/article/details/82683561" target="_blank" title="Mysql经常挂掉，挂掉后启动不起来。可能是linux 内存不足，无法分配内存缓冲池导致">
				<span class="desc oneline">Mysql经常挂掉，挂掉后启动不起来：解决步骤：1有事看日志。查看mysql的日志：more/var/log/mysqld.log    2并根据上面的日志分析出可能是linux内存不足，无法分配内存...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_29216579">来自：	<span class="blog_title"> qq_29216579的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/G1248019684/article/details/84590195","strategy":"BlogCommendFromMachineLearnPai2","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/G1248019684/article/details/84590195" target="_blank" title="内存不足导致的耗时增大">
		<h4 class="text-truncate oneline">
				<em>内存不足</em>导致的耗时增大		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-28</span>
				<span class="read-num hover-hide">
					阅读数 
					98</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/G1248019684/article/details/84590195" target="_blank" title="内存不足导致的耗时增大">
				<span class="desc oneline">内存不足导致的耗时增大给项目添加新功能，功能比较简单，就是对数据做打分过滤等操作，上线后发现CPU使用率明显上升，线程cpu使用率不均衡，有线程cpu使用率会达到100%top-H命令查看到的根据日志...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/G1248019684">来自：	<span class="blog_title"> G1248019684的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/wulantian/article/details/41119755","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wulantian/article/details/41119755" target="_blank" title="MySQL 5.6内存占用过高解决方案">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 5.6内存占用过高解决方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					5万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wulantian/article/details/41119755" target="_blank" title="MySQL 5.6内存占用过高解决方案">
				<span class="desc oneline">MySQL5.6内存占用过高解决方案作者：reizhi 发布：2013-12-2522:55 栏目：原创, 数码, 软件  阅读：1,889次  抢沙发   距离MySQL5.6正式发布已经有比较长的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wulantian">来自：	<span class="blog_title"> wulantian的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qianqian0209/article/details/78426345","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qianqian0209/article/details/78426345" target="_blank" title="mysql导入比较大的数据时出现容量不够错误">
		<h4 class="text-truncate oneline">
				<em>mysql</em>导入比较大的数据时出现容量不够错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-02</span>
				<span class="read-num hover-hide">
					阅读数 
					2092</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qianqian0209/article/details/78426345" target="_blank" title="mysql导入比较大的数据时出现容量不够错误">
				<span class="desc oneline">解决办法：查看max_allowed_packet参数适当增大max_allowed_packet参数的值可以使client端到server端传递大数据时，系统能够分配更多的扩展内存来处理。查看mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qianqian0209">来自：	<span class="blog_title"> destiny_java的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390029127","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<a href="https://bbs.csdn.net/topics/390029127" target="_blank">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>导入sql文件，out of memory问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-29</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我用程序生成一个sql文件，文件里面是一条Insert语句对应几千万条记录，文件大小1G多，通过命令行source命令导入到数据库时报错ERROR 5 (HY000): Out of memory。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"http://ask.csdn.net/questions/684925","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<a href="http://ask.csdn.net/questions/684925" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 导入外部sql文件数据报错Not enough memory		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-08</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/amohan/article/details/52229353","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/amohan/article/details/52229353" target="_blank" title="一图解决：navicat for mysql 导入.sql大文件 报out of memory 错误">
		<h4 class="text-truncate oneline">
				一图解决：navicat for <em>mysql</em> 导入.sql大文件 报out of memory 错误		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-17</span>
				<span class="read-num hover-hide">
					阅读数 
					9469</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/amohan/article/details/52229353" target="_blank" title="一图解决：navicat for mysql 导入.sql大文件 报out of memory 错误">
				<span class="desc oneline">mark一下：详情</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/amohan">来自：	<span class="blog_title"> IT部落</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/bahaidong/article/details/46289125","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bahaidong/article/details/46289125" target="_blank" title="windows 下 mysql 5.6 免安装版配置">
		<h4 class="text-truncate oneline">
				windows 下 <em>mysql</em> 5.6 免安装版配置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-31</span>
				<span class="read-num hover-hide">
					阅读数 
					356</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bahaidong/article/details/46289125" target="_blank" title="windows 下 mysql 5.6 免安装版配置">
				<span class="desc oneline">1、选择要下载的版本 http://dev.mysql.com/downloads2、解压到 D:\mysql5664（目录自定义） 复制根目录下的my-default.ini,改名为my.ini,m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bahaidong">来自：	<span class="blog_title"> bahaidong的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010433704/article/details/50517848","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010433704/article/details/50517848" target="_blank" title="mysql-bin占用空间太大的问题">
		<h4 class="text-truncate oneline">
				<em>mysql</em>-bin占用空间太大的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-14</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010433704/article/details/50517848" target="_blank" title="mysql-bin占用空间太大的问题">
				<span class="desc oneline">用ports安装了mysql以后，过一段时间发现/var空间不足了，查一下，会发现是mysql-bin.000001、mysql-bin.000002等文件占用了空间，那么这些文件是干吗的？这是数据库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010433704">来自：	<span class="blog_title"> 风的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/gdfyl/article/details/6932570","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gdfyl/article/details/6932570" target="_blank" title="MySQL配置方案">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>配置方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-03</span>
				<span class="read-num hover-hide">
					阅读数 
					292</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gdfyl/article/details/6932570" target="_blank" title="MySQL配置方案">
				<span class="desc oneline">MySQL配置方案，如my-medium.ini、my-huge(2011-09-0418:00:31)1、解压mysql-noinstall-5.1.xx-win32.zip到你喜欢的目录,例如：d...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gdfyl">来自：	<span class="blog_title"> gdfyl的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhulinu/article/details/42424303","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhulinu/article/details/42424303" target="_blank" title="mysql5.6占用内存大，通过state优化">
		<h4 class="text-truncate oneline">
				<em>mysql</em>5.6占用内存大，通过state优化		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-05</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhulinu/article/details/42424303" target="_blank" title="mysql5.6占用内存大，通过state优化">
				<span class="desc oneline">MySQL5.6相比于前代GA版本性能提升显著，但默认缓存设置对于小型站点并不合理。通过修改my.ini文件中的performance_schema_max_table_instances参数，能够有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhulinu">来自：	<span class="blog_title"> zhulinu的专栏 </span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/dm1314oooooooo/article/details/71107866","strategy":"searchFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/dm1314oooooooo/article/details/71107866" target="_blank" title="8G内存下MySQL的优化详细方案">
		<h4 class="text-truncate oneline">
				8G内存下<em>MySQL</em>的优化详细方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-03</span>
				<span class="read-num hover-hide">
					阅读数 
					3188</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/dm1314oooooooo/article/details/71107866" target="_blank" title="8G内存下MySQL的优化详细方案">
				<span class="desc oneline">对于任何一个数据库管理系统来说，内存的分配使用绝对可以算的上是其核心之一了，所以很多希望更为深入了解某数据库管理系统的人，都会希望一窥究竟，我也不例外。这里给出方案按照下面的设置试试看：key_buf...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/dm1314oooooooo">来自：	<span class="blog_title"> JoneWill</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/LiuWaiter/article/details/82869516","strategy":"BlogCommendFromQuerySearch","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/LiuWaiter/article/details/82869516" target="_blank" title="mysql 8.0 采坑总结">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 8.0 采坑总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-27</span>
				<span class="read-num hover-hide">
					阅读数 
					753</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/LiuWaiter/article/details/82869516" target="_blank" title="mysql 8.0 采坑总结">
				<span class="desc oneline">一、安装采坑mysql8.0安装成功后使用navicat打开连接，会报2059错误（1）报错提示：2059-Authenticationplugin‘caching_sha2_password’can...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/LiuWaiter">来自：	<span class="blog_title"> LiuWaiter的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/youcijibi/article/details/88256304","strategy":"BlogCommendFromQuerySearch","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/youcijibi/article/details/88256304" target="_blank" title="启动mysql时 内存不足引发的问题处理">
		<h4 class="text-truncate oneline">
				启动<em>mysql</em>时 <em>内存不足</em><em>引发</em>的问题处理		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-06</span>
				<span class="read-num hover-hide">
					阅读数 
					70</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/youcijibi/article/details/88256304" target="_blank" title="启动mysql时 内存不足引发的问题处理">
				<span class="desc oneline">报错信息如下：Outofmemoryerror:InnoDB:Fatalerror:cannotallocatememoryforthebufferpoolInnoDBcan'tstartwithou...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/youcijibi">来自：	<span class="blog_title"> youcijibi的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/360174428","strategy":"BlogCommendFromQuerySearch","index":"40"}'>
	<a href="https://bbs.csdn.net/topics/360174428" target="_blank">
		<h4 class="text-truncate oneline">
				已<em>引发</em>“<em>内存不足</em>”的问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-23</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我调试的程序中需要使用很大的内存，VS调试运行时报错：已引发“内存不足”。我将虚拟内存调整到如下图所示，rn[img=http://hi.csdn.net/attachment/201104/23/2710746_1303529162WQal.jpg][/img]rn但还是会引发内存不足，打开任务管理器查看性能选项卡，看到报错时，PF使用率只有2.51GB，见下图rn[img=http://hi.csdn.net/attachment/201104/23/2710746_13035299143mNw.jpg][/img]rn是哪里的问题呢？谢谢！rn注意，程序没有问题，不要告诉我需要更改程序,我的目的就是要测试在占用大量内存的情况下，程序的表现。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34311757/article/details/86937551","strategy":"BlogCommendFromQuerySearch","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34311757/article/details/86937551" target="_blank" title="setState 异步操作的坑">
		<h4 class="text-truncate oneline">
				setState 异步操作的坑		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-16</span>
				<span class="read-num hover-hide">
					阅读数 
					51</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34311757/article/details/86937551" target="_blank" title="setState 异步操作的坑">
				<span class="desc oneline">setState的时候遇到了一个坑。当时的需求是这样的，我们有一个modaldropdown，在点选了之后更新state，发起网络请求。虽然没有使用Redux，但是为了统一性，网络请求的参数是从sta...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34311757">来自：	<span class="blog_title"> weixin_34311757的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390441704","strategy":"BlogCommendFromQuerySearch","index":"42"}'>
	<a href="https://bbs.csdn.net/topics/390441704" target="_blank">
		<h4 class="text-truncate oneline">
				上传图片<em>引发</em><em>内存不足</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-27</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我用session保存了一下图片路径 rnrn获取之后 rnSystem.Drawing.Image image = System.Drawing.Image.FromFile(Server.MapPath(imageFile));rnrn用这样的方式继续。rnrn但是总是会提示内存不足，不知道是什么问题？、rnrnps:页面上有两个FileUpload 都是上传图片~，不知道有没有关系。。rnrnrn请大牛帮忙~~</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34410662/article/details/87224529","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34410662/article/details/87224529" target="_blank" title="记一次MySql因磁盘内存不足挂掉解决方案">
		<h4 class="text-truncate oneline">
				记一次<em>MySql</em>因磁盘<em>内存不足</em>挂掉解决方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-03</span>
				<span class="read-num hover-hide">
					阅读数 
					78</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34410662/article/details/87224529" target="_blank" title="记一次MySql因磁盘内存不足挂掉解决方案">
				<span class="desc oneline">1、网站访问不了，查看日志，发现数据库远程连接失败，查看mysql日志。image.png2、看错误情况为系统内存不足造成，解决方法升级系统内存或者添加swap（虚拟内存），centos默认虚拟内存为...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34410662">来自：	<span class="blog_title"> weixin_34410662的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34174132/article/details/90686475","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34174132/article/details/90686475" target="_blank" title="MS SQL执行大脚本文件时，提示“内存不足”的解决办法">
		<h4 class="text-truncate oneline">
				MS SQL执行大脚本文件时，提示“<em>内存不足</em>”的解决办法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-03</span>
				<span class="read-num hover-hide">
					阅读数 
					12</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34174132/article/details/90686475" target="_blank" title="MS SQL执行大脚本文件时，提示“内存不足”的解决办法">
				<span class="desc oneline">问题描述：当客户服务器不允许直接备份时，往往通过导出数据库脚本的方式来部署-还原数据库，但是当数据库导出脚本很大，用MicrosoftSQLServerManagementStudio执行脚本时，往往...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34174132">来自：	<span class="blog_title"> weixin_34174132的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_387","dest":"https://download.csdn.net/download/weixin_44163573/10887706","strategy":"BlogCommendFromBaidu","index":"45"}'>
		<a href="https://download.csdn.net/download/weixin_44163573/10887706" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						彻底解决vs报存储空间不足的错误的方法					</h4>
					<span class="data float-right">12-31</span>
				</div>
				<div class="desc oneline">
						网上一直没有此问题的解决方法，本人经过深入研究分析,已成功找出根本解决此一直困然程序员多年的方法。请下载附件查看详情。				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/340117205","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<a href="https://bbs.csdn.net/topics/340117205" target="_blank">
		<h4 class="text-truncate oneline">
				急求:如何捕获“存储空间不足”的异常		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">06-11</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">用C#写的WinForm程序，因为很多处要用到图像放大的功能，就写了一个由TrackBar和PictureBox构成的UserControl。PictureBox的SizeMode属性设为Stretc</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/GX_1_11_real/article/details/82222376","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/GX_1_11_real/article/details/82222376" target="_blank" title="mysql占用大量磁盘空间问题原因及解决方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>占用大量磁盘空间问题原因及解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-30</span>
				<span class="read-num hover-hide">
					阅读数 
					4905</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/GX_1_11_real/article/details/82222376" target="_blank" title="mysql占用大量磁盘空间问题原因及解决方法">
				<span class="desc oneline">前言我们使用mysql或者是其他的数据的时候总是会遇到数据库占用大量磁盘空间，导致磁盘空间不足，从而导致其他问题(例如：数据库重启后无法启动；数据库无法写入数据等)。要解决这一个问题，方法就是对数据库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/GX_1_11_real">来自：	<span class="blog_title"> 漠效的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u014236541/article/details/43636807","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u014236541/article/details/43636807" target="_blank" title="Mysql 配置文件，适合用于内存为 512MB 的主机">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 配置文件，适合用于内存为 512MB 的主机		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1286</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u014236541/article/details/43636807" target="_blank" title="Mysql 配置文件，适合用于内存为 512MB 的主机">
				<span class="desc oneline">Mysql配置文件，适合用于内存为512MB的主机 MYSQL小内存配置文件my.cnf[client]port=3306socket=/tmp/mysql.sock[mysqld]port=3306...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u014236541">来自：	<span class="blog_title"> 朱智文的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/deniro_li/article/details/79214100","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/deniro_li/article/details/79214100" target="_blank" title="使用 Navicat for MySQL 执行 SQL 语句时，出现 out of memory 问题的解决方法">
		<h4 class="text-truncate oneline">
				使用 Navicat for <em>MySQL</em> 执行 SQL 语句时，出现 out of memory 问题的解决方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-31</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/deniro_li/article/details/79214100" target="_blank" title="使用 Navicat for MySQL 执行 SQL 语句时，出现 out of memory 问题的解决方法">
				<span class="desc oneline">如果直接使用NavicatforMySQL的“查询”页签，执行很长内容的SQL语句（比如导入整个数据库的SQL）时，就会出现outofmemory。1分析原因很明显，因为导入整个数据库的SQL语句非常...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/deniro_li">来自：	<span class="blog_title"> 生命不息，编程不止</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/OtTaQgysNS1lZHUO0O0O.html" target="_blank">
                        人工智能技术培训的坑</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/NtDaYg4sNTgtZWR1.html" target="_blank">
                        大数据培训弃坑</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/QQ648472886">
              <img src="https://avatar.csdn.net/6/5/3/3_qq648472886.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/8.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/QQ648472886"  class="" id="uid">redmojo</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="5">
                        <dt><a href="https://blog.csdn.net/qq648472886?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/qq648472886?t=1"><span class="count">5</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="1">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">1</span></dd>
        </dl>
        <dl class="text-center" title="2">
            <dt>喜欢</dt>
            <dd><span class="count">2</span></dd>
        </dl>
        <dl class="text-center" title="2">
            <dt>评论</dt>
            <dd><span class="count">2</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="2级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-2"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="12145">
                1万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="174">
                174            </dd>
        </dl>
        <dl title="1136974">
            <dt>排名：</dt>
            <dd>113万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/QQ648472886">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/QQ648472886/article/details/78936153" target="_blank" >
                                        内存不足，mysql 导致启动失败                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/QQ648472886/article/details/78927431" target="_blank" >
                                        搭建个人的云盘--NextCloud--踩过的坑                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/QQ648472886/article/details/78910785" target="_blank" >
                                        正确配置虚拟机的IP                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/QQ648472886/article/details/52056701" target="_blank" >
                                        JPA实现对Set集合的查询                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq648472886/article/category/6335875">
                    <span class="title oneline">JPA</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/qq648472886/article/category/7371738">
                    <span class="title oneline">云盘，NextCloud</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideArchive" class="aside-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq648472886/article/month/2017/12">
                    2017年12月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/qq648472886/article/month/2016/07">
                    2016年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/QQ648472886/article/details/78927431" >
                                                搭建个人的云盘--NextCloud--踩过的坑                    </a>
					<p class="read">阅读数 <span>6947</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/QQ648472886/article/details/78936040" >
                                                mysql 内存不足引发的坑                    </a>
					<p class="read">阅读数 <span>2691</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/QQ648472886/article/details/52056701" >
                                                JPA实现对Set集合的查询                    </a>
					<p class="read">阅读数 <span>1800</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/QQ648472886/article/details/78936153" >
                                                内存不足，mysql 导致启动失败                    </a>
					<p class="read">阅读数 <span>614</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/QQ648472886/article/details/78910785" >
                                                正确配置虚拟机的IP                    </a>
					<p class="read">阅读数 <span>124</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq648472886/article/details/78927431#comments">搭建个人的云盘--NextClou...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/Esc_Tab_End" class="user-name" target="_blank">Esc_Tab_End：</a>我是在minit版本上安装的mysql，一开始缺了和你多依赖，慢慢装上了。后来装好mysql了。但是说没有什么plug插件表。我晕                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/qq648472886/article/details/78927431#comments">搭建个人的云盘--NextClou...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/Esc_Tab_End" class="user-name" target="_blank">Esc_Tab_End：</a>没解决                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">1</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/qq648472886/article/details/78927431" title="搭建个人的云盘--NextCloud--踩过的坑">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/qq648472886/article/details/78936153" title="内存不足，mysql 导致启动失败">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/qq648472886/article/details/78927431" title="搭建个人的云盘--NextCloud--踩过的坑">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/qq648472886/article/details/78936153" title="内存不足，mysql 导致启动失败">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 12;
    var articleId = "78936040";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/QQ648472886/article/details/78936040";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql 内存不足引发的坑 - QQ648472886的博客";
    var needInsertBaidu = false;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u5185\u5b58\u4e0d\u8db3","\u5f15\u53d1"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js?t=20190307095522"></script>


<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
